﻿using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Yto.Entities;

namespace com.ytocargo.Core.FlightInfos
{
    [Table("T2001")]
    public class FlightInfo:Entity
    {
        [Column("FLIGHT_ID")]
        public override int Id { get => base.Id; set => base.Id = value; }

        [Column("FLIGHT_DATE")]
        public DateTime FlightDate { get; set; }

        [Column("FLIGHT_TYPE")]
        public string FlightType { get; set; }

        [Column("FLIGHT_NO")]
        public string FlightNo { get; set; }

        [Column("AC_TYPE")]
        public string AcType { get; set; }

        [Column("AC_REG")]
        public string AcReg { get; set; }

        [Column("DEPARTURE_AIRPORT")]
        public string DepartureAirPort { get; set; }

        [Column("ARRIVAL_AIRPORT")]
        public string ArrivalAirPort { get; set; }

        [Column("PTD")]
        public DateTime? Ptd { get; set; }

        [Column("STD")]
        public DateTime Std { get; set; }

        [Column("ETD")]
        public DateTime? Etd { get; set; }

        [Column("OUT")]
        public DateTime? Out { get; set; }

        [Column("ACARS_ATD")]
        public DateTime? AcarsAtd { get; set; }

        [Column("ATD")]
        public DateTime? Atd { get; set; }


        [Column("PTA")]
        public DateTime? Pta { get; set; }

        [Column("STA")]
        public DateTime Sta { get; set; }

        [Column("ETA")]
        public DateTime? Eta { get; set; }

        [Column("ACARS_ATA")]
        public DateTime? AcarsAta { get; set; }

        [Column("ATA")]
        public DateTime? Ata { get; set; }

        [Column("INN")]
        public DateTime? Inn { get; set; }

        [Column("CLOSE_DOOR_TIME")]
        public DateTime? CloseDoorTime { get; set; }

        [Column("OPEN_DOOR_TIME")]
        public DateTime? OpenDoorTime { get; set; }

        [Column("D_OR_I")]
        public string DOrI { get; set; }

        [Column("P_OR_C")]
        public string POrC { get; set; }

        [Column("ADJUST_TYPE")]
        public string AdjustType { get; set; }

        [Column("FLG_DELAY")]
        public string FlgDelay { get; set; }

        [Column("FLG_VR")]
        public string FlgVr { get; set; }

        [Column("FLG_PATCH")]
        public string FlgPatch { get; set; }

        [Column("FLG_CS")]
        public string FlgCs { get; set; }

        [StringLength(4)]
        [Column("FPL_DIV_AIRPORT1")]
        public string FplDivAirport1 { get; set; }

        [StringLength(4)]
        [Column("FPL_DIV_AIRPORT2")]
        public string FplDivAirport2 { get; set; }
    }
}
